RAIS  3.2
C:/Projekte/RAIS/common/RADEVClasses/RADEVSummaryDataSub.cs
Go to the documentation of this file.
00001 
00002 
00003 
00004 using System;
00005 using System.Collections.Generic;
00006 using System.Data;
00007 
00008 namespace RAIS.Common.RADEVClasses
00009 {
00010     public class EventWorkPublicDosimetry:RADEVTable
00011     {
00012         #region Fields
00013         //protected const string commandString = "SELECT * FROM EventWorkPublicDosimetry";
00014                 protected const string commandString = "SELECT * FROM [RADEV Report - Event Persons Dosimetry]()";
00015                 protected const string sourceName = "RADEVData_RADEV_Summary_Sub";
00016         private static List<RADEVTable> data = new List<RADEVTable>();
00017        
00018         string _groupPerson_ID = "";
00019         string _workPubPatient = "";
00020         string _numberInGroup = "";
00021         string _wholeBodyMaxDose = "";
00022         string _wholeBodyMaxUnits = "";
00023         string _localDoseMax = "";
00024         string _localDoseMaxUnits = "";
00025         string _localSite = "";
00026         string _therapy_Diag = "";
00027         string _perCentDoseDev = "";
00028         string _over_Under = "";
00029         string _dosimetryComments = "";
00030         bool _exceedLimitsWB = false;
00031         bool _exceedLimitsExt = false;
00032         #endregion
00033         #region Properties
00034 
00035 
00036 
00037         public string DosimetryComments { get { return _dosimetryComments; } }
00041         public string Over_Under { get { return _over_Under; } }
00045         public string PerCentDoseDev { get { return _perCentDoseDev; } }
00049         public string Therapy_Diag { get { return _therapy_Diag; } }
00053         public string LocalSite { get { return _localSite; } }
00057         public string LocalDoseMaxUnits { get { return _localDoseMaxUnits; } }
00061         public string LocalDoseMax { get { return _localDoseMax; } }
00065         public string WholeBodyMaxUnits { get { return _wholeBodyMaxUnits; } }
00069         public string WholeBodyMaxDose { get { return _wholeBodyMaxDose; } }
00073         public string NumberInGroup { get { return _numberInGroup; } }
00077         public string WorkPubPatient { get { return _workPubPatient; } }
00081         public string GroupPerson_ID { get { return _groupPerson_ID; } }
00085         public bool ExceedLimitsWB { get { return _exceedLimitsWB; } }
00089         public bool ExceedLimitsExt { get { return _exceedLimitsExt; } }
00090         #endregion
00091         #region Public methods
00092 
00093 
00094 
00095 
00096         public static RADEVTable CreateInstatce()
00097         {
00098             data.Clear();
00099             return new EventWorkPublicDosimetry();
00100         }
00105         public override List<RADEVTable> GetData()
00106         {
00107             return data;
00108         }
00113         public override string GetSourceName()
00114         {
00115             return sourceName;
00116         }
00122         public override bool IsValid(RADEVCriterias criterias)
00123         {
00124             return criterias.IAEAEventID == IAEAEventID;
00125         }
00126         #endregion
00127         #region Constructors
00128         private EventWorkPublicDosimetry() { }
00129 
00130         public EventWorkPublicDosimetry(IDataReader reader)
00131             : base((string)reader["IAEAEventID"])
00132         {
00133             _groupPerson_ID = reader["GroupPerson_ID"] is DBNull ? "" : (string)reader["GroupPerson_ID"];
00134             _workPubPatient = reader["WorkPubPatient"] is DBNull ? "" : (string)reader["WorkPubPatient"];
00135             _numberInGroup = reader["NumberInGroup"] is DBNull ? "" : reader["NumberInGroup"].ToString();
00136             _wholeBodyMaxDose = reader["WholeBodyMaxDose"] is DBNull ? "" : reader["WholeBodyMaxDose"].ToString();
00137             _wholeBodyMaxUnits = reader["WholeBodyMaxUnits"] is DBNull ? "" : reader["WholeBodyMaxUnits"].ToString();
00138             _localDoseMax = reader["LocalDoseMax"] is DBNull ? "" : reader["LocalDoseMax"].ToString();
00139             _localDoseMaxUnits = reader["LocalDoseMaxUnits"] is DBNull ? "" : reader["LocalDoseMaxUnits"].ToString();
00140             _localSite = reader["LocalSite"] is DBNull ? "" : reader["LocalSite"].ToString();
00141             _therapy_Diag = reader["Therapy_Diag"] is DBNull ? "" : reader["Therapy_Diag"].ToString();
00142             _perCentDoseDev = reader["PerCentDoseDev"] is DBNull ? "" : reader["PerCentDoseDev"].ToString();
00143             _over_Under = reader["Over_Under"] is DBNull ? "" : reader["Over_Under"].ToString();
00144             _dosimetryComments = reader["DosimetryComments"] is DBNull ? "" : reader["DosimetryComments"].ToString();
00145             _exceedLimitsWB = reader["ExceedLimitsWB"] is DBNull ? false : (bool)reader["ExceedLimitsWB"];
00146             _exceedLimitsExt = reader["ExceedLimitsExt"] is DBNull ? false : (bool)reader["ExceedLimitsExt"];
00147         }
00148         #endregion
00149         #region Protcted methods
00150         protected override void AddNewRow(IDataReader reader)
00151         {
00152             data.Add(new EventWorkPublicDosimetry(reader));
00153         }
00154         protected override string GetCommandString()
00155         {
00156             return commandString;
00157         }
00158         #endregion
00159     }
00160 }